Pandas Profiling Report

Dataset info

Number of variables	27
Number of observations	904719
Missing cells	1718409 (7.0%)
Duplicate rows	0 (0.0%)
Total size in memory	180.3 MiB
Average record size in memory	209.0 B

Variables types

Numeric	3
Categorical	20
Boolean	1
Date	0
URL	0
Text (Unique)	0
Rejected	3
Unsupported	0

Warnings

`AGE_AT_INCIDENT` has 17557 (1.9%) missing values	Missing
`AOIC` has a high cardinality: 2331 distinct values	Warning
`ARRAIGNMENT_DATE` has a high cardinality: 2473 distinct values	Warning
`ARRAIGNMENT_DATE` has 127086 (14.0%) missing values	Missing
`ARREST_DATE` has a high cardinality: 269479 distinct values	Warning
`ARREST_DATE` has 30683 (3.4%) missing values	Missing
`CASE_PARTICIPANT_ID` is highly correlated with `CASE_ID` (ρ = 0.9997263254)	Rejected
`CHARGE_ID` is highly correlated with `CASE_PARTICIPANT_ID` (ρ = 0.9922534959)	Rejected
`CHARGE_OFFENSE_TITLE` has a high cardinality: 1402 distinct values	Warning
`CHARGE_VERSION_ID` is highly correlated with `CHARGE_ID` (ρ = 0.9999812286)	Rejected
`EVENT` has 21355 (2.4%) missing values	Missing
`EVENT_DATE` has a high cardinality: 2577 distinct values	Warning
`EVENT_DATE` has 21355 (2.4%) missing values	Missing
`INCIDENT_BEGIN_DATE` has a high cardinality: 4505 distinct values	Warning
`INCIDENT_BEGIN_DATE` has 11553 (1.3%) missing values	Missing
`INCIDENT_CITY` has a high cardinality: 273 distinct values	Warning
`INCIDENT_CITY` has 34905 (3.9%) missing values	Missing
`INCIDENT_END_DATE` has a high cardinality: 3792 distinct values	Warning
`INCIDENT_END_DATE` has 806298 (89.1%) missing values	Missing
`LAW_ENFORCEMENT_AGENCY` has a high cardinality: 303 distinct values	Warning
`OFFENSE_CATEGORY` has a high cardinality: 87 distinct values	Warning
`RECEIVED_DATE` only contains datetime values, but is categorical. Consider applying `pd.to_datetime()`	Type
`RECEIVED_DATE` has a high cardinality: 3258 distinct values	Warning
`SECTION` has a high cardinality: 1392 distinct values	Warning
`UNIT` has a high cardinality: 98 distinct values	Warning
`UNIT` has 633918 (70.1%) missing values	Missing
`UPDATED_OFFENSE_CATEGORY` has a high cardinality: 81 distinct values	Warning

ACT
Categorical

Distinct count	49
Unique (%)	< 0.1%
Missing (%)	< 0.1%
Missing (n)	8

5	692043
570	171596
550	25975
Other values (45)	15097

Toggle details

Common values
Composition

Value	Count	Frequency (%)
5	692043	76.5%
570	171596	19.0%
550	25975	2.9%
150	4325	0.5%
335	2428	0.3%
65	2330	0.3%
646	2016	0.2%
250	1002	0.1%
120	722	0.1%
154	543	0.1%
Other values (38)	1731	0.2%

Max length	4
Mean length	1.466991408
Min length	1
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	True

AGE_AT_INCIDENT
Numeric

Distinct count	91
Unique (%)	< 0.1%
Missing (%)	1.9%
Missing (n)	17557
Infinite (%)	0.0%
Infinite (n)	0

Mean	31.9861908
Minimum	17
Maximum	156
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	17
5-th percentile	18
Q1	22
Median	29
Q3	39
95-th percentile	55
Maximum	156
Range	139
Interquartile range	17

Descriptive statistics

Standard deviation	11.72911547
Coef of variation	0.3666931002
Kurtosis	0.2151181959
Mean	31.9861908
MAD	9.613647886
Skewness	0.9101415011
Sum	28376933
Variance	137.5721496
Memory size	6.9 MiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
19	47329	5.2%
20	47322	5.2%
21	42632	4.7%
22	40684	4.5%
23	40422	4.5%
24	38527	4.3%
25	34601	3.8%
26	33841	3.7%
18	33089	3.7%
27	31721	3.5%
Other values (80)	496994	54.9%

Minimum 5 values

Value	Count	Frequency (%)
17	12569	1.4%
18	33089	3.7%
19	47329	5.2%
20	47322	5.2%
21	42632	4.7%

Maximum 5 values

Value	Count	Frequency (%)
156	1	< 0.1%
137	2	< 0.1%
130	1	< 0.1%
127	2	< 0.1%
125	1	< 0.1%

AOIC
Categorical

Distinct count	2331
Unique (%)	0.3%
Missing (%)	0.0%
Missing (n)	0

5101110	94941
0012476	28227
0735000	28069
Other values (2328)	753482

Toggle details

Common values
Composition

Value	Count	Frequency (%)
5101110	94941	10.5%
0012476	28227	3.1%
0735000	28069	3.1%
0014717	24369	2.7%
0016108	23707	2.6%
0012309	22459	2.5%
5097200	20628	2.3%
0014716	17895	2.0%
0014056	17677	2.0%
0012474	16332	1.8%
Other values (2321)	610415	67.5%

Max length	10
Mean length	7.000704086
Min length	6
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	False

ARRAIGNMENT_DATE
Categorical

Distinct count	2473
Unique (%)	0.3%
Missing (%)	14.0%
Missing (n)	127086

6/28/2016 12:00:00 AM	1615
2/3/2015 12:00:00 AM	1005
3/20/2014 12:00:00 AM	987
Other values (2469)	774026
(Missing)	127086

Toggle details

Common values
Composition

Value	Count	Frequency (%)
6/28/2016 12:00:00 AM	1615	0.2%
2/3/2015 12:00:00 AM	1005	0.1%
3/20/2014 12:00:00 AM	987	0.1%
12/6/2011 12:00:00 AM	965	0.1%
2/14/2012 12:00:00 AM	933	0.1%
1/4/2016 12:00:00 AM	923	0.1%
9/3/2013 12:00:00 AM	920	0.1%
1/3/2017 12:00:00 AM	882	0.1%
11/6/2018 12:00:00 AM	864	0.1%
7/30/2013 12:00:00 AM	837	0.1%
Other values (2462)	767702	84.9%
(Missing)	127086	14.0%

Max length	22
Mean length	18.42302527
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

ARREST_DATE
Categorical

Distinct count	269479
Unique (%)	29.8%
Missing (%)	3.4%
Missing (n)	30683

5/18/2016 8:15:00 PM	668
3/28/2017 8:20:00 AM	495
5/19/2016 2:40:00 AM	493
Other values (269475)	872380
(Missing)	30683

Toggle details

Common values
Composition

Value	Count	Frequency (%)
5/18/2016 8:15:00 PM	668	0.1%
3/28/2017 8:20:00 AM	495	0.1%
5/19/2016 2:40:00 AM	493	0.1%
12/22/2014 10:49:00 AM	422	< 0.1%
9/28/2018 3:14:00 PM	370	< 0.1%
8/20/2014 9:33:00 AM	354	< 0.1%
2/26/2011 5:35:00 PM	342	< 0.1%
3/10/2012 1:49:00 AM	326	< 0.1%
3/1/2013 11:55:00 AM	294	< 0.1%
1/25/2012 10:40:00 AM	287	< 0.1%
Other values (269468)	869985	96.2%
(Missing)	30683	3.4%

Max length	22
Mean length	19.66057417
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

CASE_ID
Numeric

Distinct count	310135
Unique (%)	34.3%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	1.22620192e+11
Minimum	6.499985167e+10
Maximum	1.312340918e+11
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	6.499985167e+10
5-th percentile	1.15026065e+11
Q1	1.183591503e+11
Median	1.227271446e+11
Q3	1.268397286e+11
95-th percentile	1.301468348e+11
Maximum	1.312340918e+11
Range	6.623424009e+10
Interquartile range	8480578272

Descriptive statistics

Standard deviation	4914641069
Coef of variation	0.0400801939
Kurtosis	1.109886342
Mean	1.22620192e+11
MAD	4237424801
Skewness	-0.227589411
Sum	1.109368175e+17
Variance	2.415369684e+19
Memory size	6.9 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[6.49998517e+10 6.58217771e+10 6.86539147e+10 1.14069912e+11 1.14078629e+11 ... 1.31177039e+11 1.31215607e+11 1.31228857e+11 1.31228945e+11 1.31234092e+11], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
1.250925484e+11	1161	0.1%
1.158186255e+11	430	< 0.1%
1.224934163e+11	422	< 0.1%
1.261964064e+11	400	< 0.1%
1.260527791e+11	393	< 0.1%
1.207425129e+11	360	< 0.1%
1.218337121e+11	354	< 0.1%
1.244002554e+11	351	< 0.1%
1.144393396e+11	342	< 0.1%
1.194551677e+11	327	< 0.1%
Other values (310125)	900179	99.5%

Minimum 5 values

Value	Count	Frequency (%)
6.499985167e+10	105	< 0.1%
6.66437026e+10	8	< 0.1%
7.066412684e+10	2	< 0.1%
7.160552267e+10	1	< 0.1%
1.140682916e+11	8	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
1.312340918e+11	2	< 0.1%
1.31234048e+11	1	< 0.1%
1.312339166e+11	1	< 0.1%
1.312337851e+11	1	< 0.1%
1.312337413e+11	1	< 0.1%

CASE_PARTICIPANT_ID
Highly correlated

This variable is highly correlated with CASE_ID and should be ignored for analysis

Correlation	0.9997263254

CHAPTER
Categorical

Distinct count	35
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

720	761365
625	125583
730	10465
Other values (32)	7306

Toggle details

Common values
Composition

Value	Count	Frequency (%)
720	761365	84.2%
625	125583	13.9%
730	10465	1.2%
15	2428	0.3%
430	2332	0.3%
35	995	0.1%
510	427	< 0.1%
815	426	< 0.1%
765	180	< 0.1%
305	146	< 0.1%
Other values (25)	372	< 0.1%

Max length	20
Mean length	2.996214294
Min length	1
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	True

CHARGE_COUNT
Numeric

Distinct count	668
Unique (%)	0.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	6.426141155
Minimum	1
Maximum	668
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
Median	2
Q3	6
95-th percentile	21
Maximum	668
Range	667
Interquartile range	5

Descriptive statistics

Standard deviation	19.57786564
Coef of variation	3.04659751
Kurtosis	345.6398913
Mean	6.426141155
MAD	6.523871761
Skewness	15.28861255
Sum	5813852
Variance	383.2928232
Memory size	6.9 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 1. 1.5 2.5 3.5 4.5 ... 261.5 393.5 524.5 608.5 668. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
1	326742	36.1%
2	143185	15.8%
3	85710	9.5%
4	67157	7.4%
5	49179	5.4%
6	41552	4.6%
7	29391	3.2%
8	24054	2.7%
9	18031	2.0%
10	14381	1.6%
Other values (658)	105337	11.6%

Minimum 5 values

Value	Count	Frequency (%)
1	326742	36.1%
2	143185	15.8%
3	85710	9.5%
4	67157	7.4%
5	49179	5.4%

Maximum 5 values

Value	Count	Frequency (%)
668	2	< 0.1%
667	2	< 0.1%
666	2	< 0.1%
665	2	< 0.1%
664	2	< 0.1%

CHARGE_ID
Highly correlated

This variable is highly correlated with CASE_PARTICIPANT_ID and should be ignored for analysis

Correlation	0.9922534959

CHARGE_OFFENSE_TITLE
Categorical

Distinct count	1402
Unique (%)	0.2%
Missing (%)	0.0%
Missing (n)	0

AGGRAVATED UNLAWFUL USE OF WEAPON	114287
POSSESSION OF A CONTROLLED SUBSTANCE	97320
AGGRAVATED DRIVING UNDER THE INFLUENCE OF ALCOHOL	61779
Other values (1399)	631333

Toggle details

Common values
Composition

Value	Count	Frequency (%)
AGGRAVATED UNLAWFUL USE OF WEAPON	114287	12.6%
POSSESSION OF A CONTROLLED SUBSTANCE	97320	10.8%
AGGRAVATED DRIVING UNDER THE INFLUENCE OF ALCOHOL	61779	6.8%
AGGRAVATED BATTERY	57653	6.4%
FELONY DRIVING WHILE DRIVER?S LICENSE, PERMIT, OR PRIVILEGE TO OPERATE A MOTOR VEHICLE IS SUSPENDED OR REVOKED	43998	4.9%
UNLAWFUL USE OR POSSESSION OF A WEAPON BY A FELON	42372	4.7%
[POSSESSION OF CONTROLLED SUBSTANCE WITH INTENT TO DELIVER/DELIVERY OF A CONTROLLED SUBSTANCE]	37710	4.2%
FIRST DEGREE MURDER	30395	3.4%
RETAIL THEFT	23821	2.6%
[POSSESSION OF CONTROLLED SUBSTANCE WITH INTENT TO DELIVER/ DELIVERY OF A CONTROLLED SUBSTANCE]	21357	2.4%
Other values (1392)	374027	41.3%

Max length	120
Mean length	39.91095025
Min length	5
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

CHARGE_VERSION_ID
Highly correlated

This variable is highly correlated with CHARGE_ID and should be ignored for analysis

Correlation	0.9999812286

CLASS
Categorical

Distinct count	13
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

4	359203
2	204485
3	137513
Other values (10)	203518

Toggle details

Common values
Composition

Value	Count	Frequency (%)
4	359203	39.7%
2	204485	22.6%
3	137513	15.2%
X	94734	10.5%
1	76322	8.4%
M	30394	3.4%
A	1586	0.2%
B	194	< 0.1%
C	119	< 0.1%
Z	92	< 0.1%
Other values (3)	77	< 0.1%

Max length	1
Mean length	1
Min length	1
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	False

EVENT
Categorical

Distinct count	6
Unique (%)	< 0.1%
Missing (%)	2.4%
Missing (n)	21355

Preliminary Hearing	669029
Indictment	185598
Re-Indictment	16569
Other values (2)	12168
(Missing)	21355

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Preliminary Hearing	669029	73.9%
Indictment	185598	20.5%
Re-Indictment	16569	1.8%
Direct Indictment	11983	1.3%
Grand Jury	185	< 0.1%
(Missing)	21355	2.4%

Max length	19
Mean length	16.63782235
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

EVENT_DATE
Categorical

Distinct count	2577
Unique (%)	0.3%
Missing (%)	2.4%
Missing (n)	21355

11/12/2019 12:00:00 AM	1501
1/20/2015 12:00:00 AM	985
7/12/2011 12:00:00 AM	903
Other values (2573)	879975
(Missing)	21355

Toggle details

Common values
Composition

Value	Count	Frequency (%)
11/12/2019 12:00:00 AM	1501	0.2%
1/20/2015 12:00:00 AM	985	0.1%
7/12/2011 12:00:00 AM	903	0.1%
2/3/2017 12:00:00 AM	880	0.1%
8/28/2013 12:00:00 AM	877	0.1%
9/17/2014 12:00:00 AM	876	0.1%
11/19/2015 12:00:00 AM	855	0.1%
11/15/2011 12:00:00 AM	852	0.1%
12/1/2014 12:00:00 AM	835	0.1%
4/25/2017 12:00:00 AM	818	0.1%
Other values (2566)	873982	96.6%
(Missing)	21355	2.4%

Max length	22
Mean length	20.53441787
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

GENDER
Categorical

Distinct count	6
Unique (%)	< 0.1%
Missing (%)	0.5%
Missing (n)	4180

Male	803244
Female	97258
Unknown Gender	20
Other values (2)	17
(Missing)	4180

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Male	803244	88.8%
Female	97258	10.8%
Unknown Gender	20	< 0.1%
Male name, no gender given	10	< 0.1%
Unknown	7	< 0.1%
(Missing)	4180	0.5%

Max length	26
Mean length	4.210868789
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

INCIDENT_BEGIN_DATE
Categorical

Distinct count	4505
Unique (%)	0.5%
Missing (%)	1.3%
Missing (n)	11553

2/2/2016 12:00:00 AM	1347
12/17/2016 12:00:00 AM	988
1/1/2012 12:00:00 AM	929
Other values (4501)	889902
(Missing)	11553

Toggle details

Common values
Composition

Value	Count	Frequency (%)
2/2/2016 12:00:00 AM	1347	0.1%
12/17/2016 12:00:00 AM	988	0.1%
1/1/2012 12:00:00 AM	929	0.1%
10/19/2013 12:00:00 AM	918	0.1%
7/17/2017 12:00:00 AM	852	0.1%
1/1/2013 12:00:00 AM	843	0.1%
9/29/2015 12:00:00 AM	823	0.1%
11/5/2011 12:00:00 AM	737	0.1%
1/1/2011 12:00:00 AM	694	0.1%
2/11/2012 12:00:00 AM	670	0.1%
Other values (4494)	884365	97.8%
(Missing)	11553	1.3%

Max length	22
Mean length	20.69319866
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

INCIDENT_CITY
Categorical

Distinct count	273
Unique (%)	< 0.1%
Missing (%)	3.9%
Missing (n)	34905

Chicago	614613
Cicero	13221
Harvey	9787
Other values (269)	232193
(Missing)	34905

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Chicago	614613	67.9%
Cicero	13221	1.5%
Harvey	9787	1.1%
Chicago Heights	7680	0.8%
Calumet City	7630	0.8%
Berwyn	6608	0.7%
Dolton	6209	0.7%
Orland Park	5779	0.6%
Oak Lawn	5561	0.6%
Evanston	5270	0.6%
Other values (262)	187456	20.7%
(Missing)	34905	3.9%

Max length	21
Mean length	7.60697852
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

INCIDENT_END_DATE
Categorical

Distinct count	3792
Unique (%)	0.4%
Missing (%)	89.1%
Missing (n)	806298

8/22/2011 12:00:00 AM	590
2/28/2013 12:00:00 AM	462
1/19/2017 12:00:00 AM	408
Other values (3788)	96961
(Missing)	806298

Toggle details

Common values
Composition

Value	Count	Frequency (%)
8/22/2011 12:00:00 AM	590	0.1%
2/28/2013 12:00:00 AM	462	0.1%
1/19/2017 12:00:00 AM	408	< 0.1%
9/30/2015 12:00:00 AM	345	< 0.1%
9/11/2011 12:00:00 AM	335	< 0.1%
10/31/2014 12:00:00 AM	327	< 0.1%
1/31/2007 12:00:00 AM	287	< 0.1%
7/23/2014 12:00:00 AM	275	< 0.1%
2/10/2016 12:00:00 AM	256	< 0.1%
6/30/2011 12:00:00 AM	254	< 0.1%
Other values (3781)	94882	10.5%
(Missing)	806298	89.1%

Max length	22
Mean length	4.954424523
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

LAW_ENFORCEMENT_AGENCY
Categorical

Distinct count	303
Unique (%)	< 0.1%
Missing (%)	0.4%
Missing (n)	3712

CHICAGO PD	604604
COOK COUNTY SHERIFF (IL0160000)	24233
CICERO PD	13601
Other values (299)	258569

Toggle details

Common values
Composition

Value	Count	Frequency (%)
CHICAGO PD	604604	66.8%
COOK COUNTY SHERIFF (IL0160000)	24233	2.7%
CICERO PD	13601	1.5%
HARVEY PD	8478	0.9%
CHICAGO HEIGHTS PD	7906	0.9%
CALUMET CITY PD	7249	0.8%
ISP DISTRICT CHICAGO	6600	0.7%
BERWYN PD	6588	0.7%
ORLAND PARK PD	6580	0.7%
DOLTON PD	5777	0.6%
Other values (292)	209391	23.1%

Max length	60
Mean length	11.87566416
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

OFFENSE_CATEGORY
Categorical

Distinct count	87
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

Narcotics	190542
UUW - Unlawful Use of Weapon	166621
Aggravated DUI	56761
Other values (84)	490795

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Narcotics	190542	21.1%
UUW - Unlawful Use of Weapon	166621	18.4%
Aggravated DUI	56761	6.3%
Sex Crimes	47812	5.3%
Homicide	43345	4.8%
Driving With Suspended Or Revoked License	35736	3.9%
Armed Robbery	29725	3.3%
Aggravated Battery Police Officer	26920	3.0%
Retail Theft	24302	2.7%
Aggravated Battery	20299	2.2%
Other values (77)	262656	29.0%

Max length	45
Mean length	17.27411495
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

PRIMARY_CHARGE
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

False	577977
True	326742

Toggle details

Value	Count	Frequency (%)
False	577977	63.9%
True	326742	36.1%

RACE
Categorical

Distinct count	13
Unique (%)	< 0.1%
Missing (%)	0.6%
Missing (n)	5791

Black	601981
White [Hispanic or Latino]	156302
White	116238
Other values (9)	24407

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Black	601981	66.5%
White [Hispanic or Latino]	156302	17.3%
White	116238	12.8%
HISPANIC	11126	1.2%
Asian	6492	0.7%
White/Black [Hispanic or Latino]	4692	0.5%
Unknown	1549	0.2%
American Indian	429	< 0.1%
Biracial	111	< 0.1%
ASIAN	6	< 0.1%
Other values (2)	2	< 0.1%
(Missing)	5791	0.6%

Max length	32
Mean length	8.800680653
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

RECEIVED_DATE
Categorical

Distinct count	3258
Unique (%)	0.4%
Missing (%)	0.0%
Missing (n)	0

5/19/2016 12:00:00 AM	1499
10/21/2013 12:00:00 AM	995
12/17/2016 12:00:00 AM	918
Other values (3255)	901307

Toggle details

Common values
Composition

Value	Count	Frequency (%)
5/19/2016 12:00:00 AM	1499	0.2%
10/21/2013 12:00:00 AM	995	0.1%
12/17/2016 12:00:00 AM	918	0.1%
10/22/2015 12:00:00 AM	905	0.1%
10/18/2011 12:00:00 AM	904	0.1%
8/27/2018 12:00:00 AM	808	0.1%
8/23/2011 12:00:00 AM	775	0.1%
1/25/2012 12:00:00 AM	759	0.1%
9/24/2013 12:00:00 AM	735	0.1%
12/23/2014 12:00:00 AM	722	0.1%
Other values (3248)	895699	99.0%

Max length	22
Mean length	20.93898658
Min length	20
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

SECTION
Categorical

Distinct count	1392
Unique (%)	0.2%
Missing (%)	< 0.1%
Missing (n)	8

402(c)	94894
24-1.6(a)(1)	88050
11-501(a)	61943
Other values (1388)	659824

Toggle details

Common values
Composition

Value	Count	Frequency (%)
402(c)	94894	10.5%
24-1.6(a)(1)	88050	9.7%
11-501(a)	61943	6.8%
6-303(a)	46530	5.1%
24-1.1(a)	42372	4.7%
24-1.6(a)(2)	37662	4.2%
12-3.05(d)(4)	23692	2.6%
401(d)(i)	20608	2.3%
16-25(a)(1)	19346	2.1%
8-4(a)(720-5/9-1(a)(1))	16925	1.9%
Other values (1381)	452689	50.0%

Max length	30
Mean length	9.813814013
Min length	1
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

UNIT
Categorical

Distinct count	98
Unique (%)	< 0.1%
Missing (%)	70.1%
Missing (n)	633918

District 11 - Harrison	51987
District 10 - Ogden	21797
District 15 - Austin	18829
Other values (94)	178188
(Missing)	633918

Toggle details

Common values
Composition

Value	Count	Frequency (%)
District 11 - Harrison	51987	5.7%
District 10 - Ogden	21797	2.4%
District 15 - Austin	18829	2.1%
District 7 - Englewood	18240	2.0%
District 6 - Gresham	15448	1.7%
District 25 - Grand Central	14441	1.6%
District 5 - Calumet	12603	1.4%
District 9 - Deering	12433	1.4%
District 8 - Chicago Lawn	12088	1.3%
District 4 - South Chicago	11640	1.3%
Other values (87)	81295	9.0%
(Missing)	633918	70.1%

Max length	57
Mean length	8.981180897
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

UPDATED_OFFENSE_CATEGORY
Categorical

Distinct count	81
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

Narcotics	198825
UUW - Unlawful Use of Weapon	171125
Aggravated DUI	70872
Other values (78)	463897

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Narcotics	198825	22.0%
UUW - Unlawful Use of Weapon	171125	18.9%
Aggravated DUI	70872	7.8%
Sex Crimes	48287	5.3%
Homicide	43668	4.8%
Aggravated Battery With A Firearm	36900	4.1%
Driving With Suspended Or Revoked License	36263	4.0%
Armed Robbery	30529	3.4%
Aggravated Battery Police Officer	28874	3.2%
Theft	24546	2.7%
Other values (71)	214830	23.7%

Max length	45
Mean length	17.76765382
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

First rows

	ACT	AGE_AT_INCIDENT	AOIC	ARRAIGNMENT_DATE	ARREST_DATE	CASE_ID	CASE_PARTICIPANT_ID	CHAPTER	CHARGE_COUNT	CHARGE_ID	CHARGE_OFFENSE_TITLE	CHARGE_VERSION_ID	CLASS	EVENT	EVENT_DATE	GENDER	INCIDENT_BEGIN_DATE	INCIDENT_CITY	INCIDENT_END_DATE	LAW_ENFORCEMENT_AGENCY	OFFENSE_CATEGORY	PRIMARY_CHARGE	RACE	RECEIVED_DATE	SECTION	UNIT	UPDATED_OFFENSE_CATEGORY
0	5	22.0	0735100	7/11/2011 12:00:00 AM	5/22/2011 6:51:00 PM	64999851671	260122253823	720	2	2037067609997	FIRST DEGREE MURDER	462725085037	M	Preliminary Hearing	6/20/2011 12:00:00 AM	Male	3/12/2007 12:00:00 AM	NaN	NaN	PROMIS Data Conversion	PROMIS Conversion	False	Black	5/24/2011 12:00:00 AM	9-1(a)(2)	NaN	Homicide
1	5	22.0	0735200	7/11/2011 12:00:00 AM	5/22/2011 6:51:00 PM	64999851671	260122253823	720	3	2037073820980	FIRST DEGREE MURDER	462726494735	M	Preliminary Hearing	6/20/2011 12:00:00 AM	Male	3/12/2007 12:00:00 AM	NaN	NaN	PROMIS Data Conversion	PROMIS Conversion	False	Black	5/24/2011 12:00:00 AM	9-1(a)(3)	NaN	Homicide
2	5	22.0	0735200	7/11/2011 12:00:00 AM	5/22/2011 6:51:00 PM	64999851671	260122253823	720	4	2037079144680	FIRST DEGREE MURDER	462727770177	M	Preliminary Hearing	6/20/2011 12:00:00 AM	Male	3/12/2007 12:00:00 AM	NaN	NaN	PROMIS Data Conversion	PROMIS Conversion	False	Black	5/24/2011 12:00:00 AM	9-1(a)(3)	NaN	Homicide
3	5	22.0	0735200	7/11/2011 12:00:00 AM	5/22/2011 6:51:00 PM	64999851671	260122253823	720	5	2037080919246	FIRST DEGREE MURDER	462728172948	M	Preliminary Hearing	6/20/2011 12:00:00 AM	Male	3/12/2007 12:00:00 AM	NaN	NaN	PROMIS Data Conversion	PROMIS Conversion	False	Black	5/24/2011 12:00:00 AM	9-1(a)(3)	NaN	Homicide
4	5	22.0	0735200	7/11/2011 12:00:00 AM	5/22/2011 6:51:00 PM	64999851671	260122253823	720	6	2037084172619	FIRST DEGREE MURDER	462728911361	M	Preliminary Hearing	6/20/2011 12:00:00 AM	Male	3/12/2007 12:00:00 AM	NaN	NaN	PROMIS Data Conversion	PROMIS Conversion	False	Black	5/24/2011 12:00:00 AM	9-1(a)(3)	NaN	Homicide
5	5	22.0	0735200	7/11/2011 12:00:00 AM	5/22/2011 6:51:00 PM	64999851671	260122253823	720	7	2037085059902	FIRST DEGREE MURDER	462729112747	M	Preliminary Hearing	6/20/2011 12:00:00 AM	Male	3/12/2007 12:00:00 AM	NaN	NaN	PROMIS Data Conversion	PROMIS Conversion	False	Black	5/24/2011 12:00:00 AM	9-1(a)(3)	NaN	Homicide
6	5	22.0	0735200	7/11/2011 12:00:00 AM	5/22/2011 6:51:00 PM	64999851671	260122253823	720	8	2037086242946	FIRST DEGREE MURDER	462729381261	M	Preliminary Hearing	6/20/2011 12:00:00 AM	Male	3/12/2007 12:00:00 AM	NaN	NaN	PROMIS Data Conversion	PROMIS Conversion	False	Black	5/24/2011 12:00:00 AM	9-1(a)(3)	NaN	Homicide
7	5	22.0	0735200	7/11/2011 12:00:00 AM	5/22/2011 6:51:00 PM	64999851671	260122253823	720	9	2037087425991	FIRST DEGREE MURDER	462729649775	M	Preliminary Hearing	6/20/2011 12:00:00 AM	Male	3/12/2007 12:00:00 AM	NaN	NaN	PROMIS Data Conversion	PROMIS Conversion	False	Black	5/24/2011 12:00:00 AM	9-1(a)(3)	NaN	Homicide
8	5	22.0	0735200	7/11/2011 12:00:00 AM	5/22/2011 6:51:00 PM	64999851671	260122253823	720	10	2037088313274	FIRST DEGREE MURDER	462729851160	M	Preliminary Hearing	6/20/2011 12:00:00 AM	Male	3/12/2007 12:00:00 AM	NaN	NaN	PROMIS Data Conversion	PROMIS Conversion	False	Black	5/24/2011 12:00:00 AM	9-1(a)(3)	NaN	Homicide
9	5	22.0	0735200	7/11/2011 12:00:00 AM	5/22/2011 6:51:00 PM	64999851671	260122253823	720	11	2037089200557	FIRST DEGREE MURDER	462730052545	M	Preliminary Hearing	6/20/2011 12:00:00 AM	Male	3/12/2007 12:00:00 AM	NaN	NaN	PROMIS Data Conversion	PROMIS Conversion	False	Black	5/24/2011 12:00:00 AM	9-1(a)(3)	NaN	Homicide

Last rows

	ACT	AGE_AT_INCIDENT	AOIC	ARRAIGNMENT_DATE	ARREST_DATE	CASE_ID	CASE_PARTICIPANT_ID	CHAPTER	CHARGE_COUNT	CHARGE_ID	CHARGE_OFFENSE_TITLE	CHARGE_VERSION_ID	CLASS	EVENT	EVENT_DATE	GENDER	INCIDENT_BEGIN_DATE	INCIDENT_CITY	INCIDENT_END_DATE	LAW_ENFORCEMENT_AGENCY	OFFENSE_CATEGORY	PRIMARY_CHARGE	RACE	RECEIVED_DATE	SECTION	UNIT	UPDATED_OFFENSE_CATEGORY
904709	5	28.0	0012474	NaN	12/1/2019 3:49:00 PM	131233522335	1101542423116	720	2	2585370245907	AGGRAVATED UNLAWFUL USE OF WEAPON	589641702315	4	NaN	NaN	Male	12/1/2019 12:00:00 AM	Broadview	NaN	BROADVIEW PD	UUW - Unlawful Use of Weapon	False	Black	12/1/2019 12:00:00 AM	24-1.6(a)(1)	NaN	UUW - Unlawful Use of Weapon
904710	5	28.0	0012474	NaN	12/1/2019 3:49:00 PM	131233522335	1101542423116	720	1	2585369950146	AGGRAVATED UNLAWFUL USE OF WEAPON	589641635187	4	NaN	NaN	Male	12/1/2019 12:00:00 AM	Broadview	NaN	BROADVIEW PD	UUW - Unlawful Use of Weapon	True	Black	12/1/2019 12:00:00 AM	24-1.6(a)(1)	NaN	UUW - Unlawful Use of Weapon
904711	5	27.0	0012475	NaN	12/1/2019 11:35:00 AM	131233609939	1101543243921	720	1	2585370541668	AGGRAVATED UNLAWFUL USE OF WEAPON	589641769444	2	NaN	NaN	Male	12/1/2019 12:00:00 AM	Chicago	NaN	CHICAGO PD	UUW - Unlawful Use of Weapon	True	Black	12/1/2019 12:00:00 AM	24-1.6(a)(1)	NaN	UUW - Unlawful Use of Weapon
904712	5	44.0	0013855	NaN	12/1/2019 6:55:00 PM	131233697543	1101544416501	720	1	2585370837429	ARMED HABITUAL CRIMINAL	589641836572	X	NaN	NaN	Male	12/1/2019 12:00:00 AM	Chicago	NaN	CHICAGO PD	UUW - Unlawful Use of Weapon	True	Black	12/1/2019 12:00:00 AM	24-1.7(a)	NaN	UUW - Unlawful Use of Weapon
904713	5	32.0	0017862	NaN	12/1/2019 5:59:00 PM	131233741345	1101545002791	720	1	2585371133190	AGGRAVATED UNLAWFUL USE OF WEAPON	589641903701	4	NaN	NaN	Male	12/1/2019 12:00:00 AM	Chicago	NaN	CHICAGO PD	UUW - Unlawful Use of Weapon	True	HISPANIC	12/1/2019 12:00:00 AM	24-1.6(a)(1)	NaN	UUW - Unlawful Use of Weapon
904714	5	29.0	1214500	NaN	12/1/2019 8:18:00 PM	131233785148	1101545354565	720	1	2585371428951	UNLAWFUL USE OR POSSESSION OF A WEAPON BY A FELON	589641970829	3	NaN	NaN	Male	12/1/2019 12:00:00 AM	Chicago	NaN	CHICAGO PD	UUW - Unlawful Use of Weapon	True	Black	12/1/2019 12:00:00 AM	24-1.1(a)	NaN	UUW - Unlawful Use of Weapon
904715	5	25.0	0015296	NaN	12/1/2019 6:50:00 PM	131233916554	1101546878918	720	1	2585371724712	BOARD AIRCRAFT WITH WEAPON	589642037958	4	NaN	NaN	Male	12/1/2019 12:00:00 AM	Chicago	NaN	CHICAGO PD	UUW - Unlawful Use of Weapon	True	White	12/1/2019 12:00:00 AM	29D-35.1(a)	NaN	UUW - Unlawful Use of Weapon
904716	5	19.0	1100000	NaN	12/1/2019 9:37:00 PM	131234047960	1101548872304	720	1	2585372020473	ROBBERY	589642105086	2	NaN	NaN	Male	12/1/2019 12:00:00 AM	Chicago	NaN	CHICAGO PD	Robbery	True	Black	12/2/2019 12:00:00 AM	18-1(a)	NaN	Robbery
904717	5	21.0	1115000	NaN	12/1/2019 11:25:00 PM	131234091763	1101549575851	720	2	2585372611996	POSSESSION OF BURGLARY TOOLS	589642239343	4	NaN	NaN	Male	12/1/2019 12:00:00 AM	Hoffman Estates	NaN	HOFFMAN ESTATES PD	Burglary	False	White	12/2/2019 12:00:00 AM	19-2(a)	NaN	Burglary
904718	5	21.0	1110000	NaN	12/1/2019 11:25:00 PM	131234091763	1101549575851	720	1	2585372316235	ATTEMPT BURGLARY	589642172215	3	NaN	NaN	Male	12/1/2019 12:00:00 AM	Hoffman Estates	NaN	HOFFMAN ESTATES PD	Burglary	True	White	12/2/2019 12:00:00 AM	8-4(19-1(a))	NaN	Burglary

Overview

Variables

Correlations

Missing values

Sample

First rows

Last rows